﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Zor_IDAL;

namespace Zor_DAL
{
    public class AHouseholdTax_DAL<T> where T : class
    {   
        /// <summary>
        /// 获取部分也的列表数据
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public static List<T> SelectViewAHouseholdTax(string where)
        {
            string strwhere = "";
            if (!string.IsNullOrEmpty(where))
            {
                strwhere = " NatPer_IDNumber = '"+where+"' ";
            }
            else
            {
                strwhere = "1=1 "; 
            }
            var sql = "select * from [dbo].[V_AHouseholdTax] where " + strwhere + " order by Pt_Id";
            return DapperQuery<T>.DoQueryList(sql, null);
        }
    }
}
